|
|
#93296
06/26/2004 3:45 PM
|
Joined: Jun 2004
Posts: 6
Lurker
|
|
Lurker
Joined: Jun 2004
Posts: 6 |
I need someone to optimize MySQL on my Apple Xserve.
Here are the specs:
1. Mac OS X Server 10.2.8
2. MySQL 4.0.18 - 2 Databases (24MB & 197MB)
3. Apache 2.0.49 - 55 Virtual Hosts
Occasionally, the larger database become inaccessible - pages in the forums cannot be accessed. During this time, there are usually quite a few "locked" MySQL processes relating to this database. As soon as MySQL is restarted, the forums function properly for several more hours.
I have optimized a couple of the largest tables in this database several times, but that doesn't seem to have an effect.
I can provide 24 hour system-wide access via SSH in order to optimize MySQL.
|
|
|
#93297
07/07/2004 5:16 PM
|
Joined: Jun 2001
Posts: 729
Coder
|
|
Coder
Joined: Jun 2001
Posts: 729 |
Backup your my.cnf and try this... [mysqld]
datadir=/usr/local/mysql
socket=/var/lib/mysql/mysql.sock
set-variable = max_connections=450
set-variable = key_buffer=16M
set-variable = myisam_sort_buffer_size=64M
set-variable = join_buffer=1M
set-variable = record_buffer=1M
set-variable = sort_buffer=2M
set-variable = table_cache=1024
set-variable = thread_cache_size=256
set-variable = wait_timeout=9600
set-variable = connect_timeout=10
set-variable = max_allowed_packet=16M
set-variable = max_connect_errors=10
[mysql.server]
user=mysql
basedir=/usr/local/mysql
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
open_files_limit=8192
[mysqldump]
quick
set-variable = max_allowed_packet=16M
[myisamchk]
set-variable = key_buffer=64M
set-variable = sort_buffer=64M
set-variable = read_buffer=16M
set-variable = write_buffer=16M
|
|
|
Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.
Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
|
|
|
Posts: 5,834
Joined: January 2000
|
|
|
Forums63
Topics37,583
Posts293,955
Members13,824
| |
Most Online151,614
Nov 14th, 2025
|
|
Currently Online 655
Topics Created 0
Posts Made 0
Users Online 0
Birthdays 9
|
|
|
|
|
|
